package com.etone.smartAudit.mapper;

import com.etone.smartAudit.vo.auditExceptionCityReport.AuditExceptionCityReportHeaderVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * @author: sovy
 * @date: 2021/1/18
 * @description:
 */

@Mapper
public interface AuditExceptionCityReportMapper {

    List<String> findAllCity();

    /**
     * 获取表头信息
     *
     * @param database
     * @return
     */
    List<AuditExceptionCityReportHeaderVO> findTableColumn(@Param("database") String database);

    /**
     * 获取数据
     *
     * @param cityName
     * @param date
     * @param ids
     * @param fields
     * @return
     */
    List<Map<String, Object>> findList(@Param("cityName") String cityName, @Param("date") String date, @Param("ids") List<Integer> ids, @Param("fields") List<String> fields);

    /**
     * 查找单条记录
     *
     * @param id
     * @param fields
     * @return
     */
    Map<String, Object> findOne(@Param("id") Integer id, @Param("fields") List<String> fields);

}